﻿using supermarket.method;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace myproject.method
{
    internal class Classsupnumberwarn
    {
        SqlConnection con = new SqlConnection();
        SqlCommand cmd = new SqlCommand();
        SqlDataReader qlddr = null;  //数据缓冲区

        #region///药品库存预警数量设置
        public void supselectnumber(string nu)
        {
            try
            {
                string s;
                //1.连接数据库
                Classgetsql sqlcon = new Classgetsql();
                con = sqlcon.getcon();  //数据库已连接并打开

                s = "select * from Table_gift where number<='" + nu + "'";   //无条件查询
                cmd = new SqlCommand(s, con);   //执行SQL语句
                cmd.ExecuteNonQuery();   //受影响的行数

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }




        }
        #endregion

    }
}
